package org.vectrics.recruiter.reporting;

import java.util.Date;

import org.vectrics.hibernate.Filter;
import org.vectrics.recruiter.job.JobStatusType;

public class CreatedJobsStatQuery extends TimeQuery {

	
	protected Filter getFilter(Date startTime, Date endTime) {
		Filter filter = new Filter();
		filter.addFrom("Job", "job");
		filter.addSelectField("count(distinct job.id)");
		filter.addParameterCondition("job.createdDate", ">", startTime);
		filter.addParameterCondition("job.createdDate", "<", endTime);
		filter.addCondition("job.voided='F'");
		return(filter);
	}
}
